| |
109 Search Results Found |
| 1 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 07:01 «»
By: Andrey_R
RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…a scenario when I want to restore a table MYUSER.T1 from a previous date.
I have no archive log backups, no SPFILE/CTL file backups.
I only have a backup of the database from a time I want to restore the table to.
I do have a SPFILE/Control …
|
| 2 |
Forum: Server Utilities «»
Posted on: Mon, 15 April 2024 21:19 «»
By: wtolentino
impd data only on the same database from one table to another table
…
I tried this impdp with no success
impdp myUser@myDB/****** tables=myUser.sample_tab_import01 content=data_only remap_table=myUser.sample_tab_import01:sample_tab_import02 table_exists_action=truncate nologfile=yes 1>impdp_myDB.log 2>&1
I …
|
| 3 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 09:41 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…
RMAN> RUN {
2> RESTORE TABLE "MYUSER"."T1";
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571…
|
| 4 |
Forum: Backup & Recovery «»
Posted on: Fri, 07 July 2023 05:28 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…! And I was surprised to see that my table MYUSER.T1 was missing from it! 8o ..
I wonder whether it's the corruption in the files I "allowed" or something in my technique that caused this..
But I did expect that I could at least …
|
| 5 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 07:57 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…result
RMAN> RECOVER TABLE "MYUSER"."T1"
2> UNTIL TIME "TO_DATE('06.07.2023 11:47:00', 'DD-MM-YYYY HH24:MI:SS')"
3> AUXILIARY DESTINATION 'G:\MYAUX'
4> REMAP TABLE 'MYUSER'.'T1':'T1_RECOVERED';
Starting…
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 29 October 2021 15:35 «»
By: Andrey_R
Re: Data Dictionary for Collection Bind variables
…
It errors for me:
C:\Users\myuser>sqlplus a/a
SQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 29 23:32:58 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Last Successful login time: Fri Oct 29 2021 …
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 27 October 2021 08:44 «»
By: Andrey_R
Re: Data Dictionary for Collection Bind variables
…
Try this
Session 1:
C:\Users\myuser>sqlplus a/a
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Oct 27 16:37:00 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Last Successful login time: Wed …
|
| 8 |
Forum: Performance Tuning «»
Posted on: Thu, 11 February 2021 06:19 «»
By: Andrey_R
TKPROF showing wrong totals for non-recursive statements
…file, which I tkprof'ed with
C:\...myuser>tkprof D:\SOMEPATH...\MYDB_ora_26950.trc D:\SOMEPATH...\MYDB_ora_26950.tkprf sort=exeela,fchela,prsela
TKPROF: Release 12.1.0.2.0 - Development on Thu Feb 11 11:16:34 2021
Copyright (c) 1982, 2014…
|
| 9 |
Forum: Server Administration «»
Posted on: Wed, 18 November 2020 03:22 «»
By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…regular drop table:
SQL> Alter session set events '10851 trace name context forever, level 2';
Session altered.
SQL> drop table MYUSER.AQ$_SOMELOGIC_QTABLE_L;
Table dropped.
SQL>
It worked !!!
Great thanks Michel…
|
| 10 |
Forum: Server Administration «»
Posted on: Tue, 17 November 2020 11:58 «»
By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…ist:
SQL> show user
USER is "MYUSER"
SQL>
SQL>
SQL> col owner for a30
SQL> col table_name for a50
SQL>
SQL> select owner,table_name from dba_tables where owner = user and table_name like 'AQ$%';
OWNER…
|
| 11 |
Forum: Server Administration «»
Posted on: Tue, 17 November 2020 11:27 «»
By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…
SQL>
SQL> show user
USER is "MYUSER"
SQL>
SQL>
SQL> select owner,name,queue_table,queue_type
2 from dba_queues
3 where owner = 'MYUSER'
4 order by 1, 2, 3;
no rows selected
SQL>
SQL>
SQL>
SQL>…
|
| 12 |
Forum: Server Administration «»
Posted on: Sun, 08 November 2020 06:04 «»
By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
… time I hope.
I am querying the queues of MYUSER, no results:
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
SQL> conn MYUSER/password@connstring
Connected.
SQL>
SQL>
SQL> select * from …
|
| 13 |
Forum: Server Administration «»
Posted on: Thu, 29 October 2020 10:54 «»
By: Andrey_R
ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…= 'AQ$_SOMELOGIC_QTABLE' AND OWNER = 'MYUSER';
OWNER TABLE_NAME STATUS
------------------------------ ----------------------------------- --------------------
MYUSER AQ$…
|
| 14 |
Forum: Security «»
Posted on: Sun, 09 August 2020 07:34 «»
By: Andrey_R
Re: Username in lowercase authentication issues
…database:
C:\Documents and Settings\myuser>sqlplus "test"/"test"@mydb
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 9 15:24:45 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: …
|
| 15 |
Forum: Security «»
Posted on: Sun, 09 August 2020 05:44 «»
By: Andrey_R
Re: Username in lowercase authentication issues
…Corp.
C:\Documents and Settings\myuser>sqlplus "test"/"test"@mydb
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 9 13:40:55 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid …
|
| 16 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 15 July 2020 04:36 «»
By: Andrey_R
How to Inherit data default from %TYPE attribute for a variable
…:
ORA-01400: cannot insert NULL into ("MYUSER"."TEST"."COL1")
ORA-06512: at line 4
I did read some documentation saying I can't do that in here => https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 17 January 2019 12:00 «»
By: Andrey_R
ORA-01843 on a simple query
… from dual
*
ERROR at line 1:
ORA-00911: invalid character
SQL> show user
USER is "MYUSER"
SQL>
Any ideas where is it coming from, what am I missing ?
TIA
…
|
| 18 |
Forum: Performance Tuning «»
Posted on: Thu, 01 November 2018 04:31 «»
By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 20149 out of 221372 Blocks done
6 100554 .986644979026% 17 0 Rowid Range Scan: MYUSER.MYTAB: 2305 out of 233620 Blocks done…
|
| 19 |
Forum: Performance Tuning «»
Posted on: Wed, 31 October 2018 13:31 «»
By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 17237 out of 298731 Blocks done
73674 7.11329195637% 94 0 Rowid Range Scan: MYUSER.MYTAB: 16584 out of 233141 Blocks done
72710 …
|
| 20 |
Forum: Performance Tuning «»
Posted on: Wed, 31 October 2018 08:50 «»
By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 19943 out of 233491 Blocks done
52366 8.617250011849% 82 0 Rowid Range Scan: MYUSER.MYTAB: 19999 out of 232081 Blocks done
52205 …
|
| 21 |
Forum: Networking and Gateways «»
Posted on: Mon, 29 October 2018 12:26 «»
By: JPBoileau
Re: Unsuccessful of establishment of database link from oracle to sql server
…DS_TRACE_LEVEL=ON
HS_FDS_RECOVERY_ACCOUNT=myuser
HS_FDS_RECOVERY_PWD=mypwd
3) A TNSNames Entry in the Database Oracle Home that points to the listener defined in 1) above with the "HS = OK" parameter
DG4MSQL =
(DESCRIPTION…
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 29 October 2018 10:57 «»
By: Andrey_R
Re: date column displays strange output
…g.DATECOL1 < to_date('01/01/2000', 'dd/mm/yyyy');
select distinct bad_date(dt => g.DATECOL1 ) from MYTAB g
*
ERROR at line 1:
ORA-01843: not a valid month
ORA-06512: at "MYUSER.BAD_DATE", line 21
SQL>…
|
| 23 |
Forum: Security «»
Posted on: Wed, 25 July 2018 07:25 «»
By: EdStevens
Re: Authentication and passwordfile
… if you request a TNS connection:
sqlplus myuser/mypassword@mydatabase
THEN authentication will be to consult the password file for 'mydatabase', to see if there is an entry for 'myuser' and that his password is 'mypassword'.
And with TNS …
|
| 24 |
Forum: General «»
Posted on: Mon, 08 January 2018 07:59 «»
By: BlackSwan
Re: SQL Report running manually not through cron
You can create & SQLPLUS will utilize your own private copy of tnsnmes.ora when named as below
/data/myuser/user1/.tnsnames.ora
Notice that there is a dot (".") preceding and as part of actual filename.
|
| 25 |
Forum: General «»
Posted on: Fri, 05 January 2018 21:54 «»
By: dba4oracle
Re: SQL Report running manually not through cron
…
below is env.capture
HOME=/data/myuser/user1
HOST=IAPL1
LANG=en_US.UTF-8
LOGNAME=user1
MAILTO=myuser@mycompany.com
ORACLE_HOME=/opt/u01/app/oracle/product/11.2.0.4/client
PASSWORD=abc123
PATH=/opt/u01/app/oracle/product/11.2.0.4/client…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 19 September 2016 06:37 «»
By: bluetooth420
Re: Missing Record in running Total
…quot;MOS"."VCUSTHIST1" ("MYUSER", "TTYPE", "CCODE", "CODE", "CNAME", "DATED", "DETAIL", "AMOUNT", "AORS", "REF", "REMARKS") AS…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 June 2016 07:39 «»
By: EdStevens
Re: How To Update Encrypted Password for all user id's using Update Query
Really?
Have you seen what happens when you 'sqlplus myuser/p@ssword123@mydb'
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 18 December 2015 13:55 «»
By: EdStevens
Re: dbms_ldap.simple_bind_s doesn't work with PW containing "!"
… denoted by a "@" (as in 'sqlplus myuser/mypwd@orcl'), if the password is also included and the password contains an "@", it causes the parser to short the password and try to make the rest of it the connect string. I've also known …
|
| 29 |
Forum: Server Administration «»
Posted on: Mon, 16 November 2015 09:01 «»
By: pkirklewski
Re: TNS-03502: Message 3502 not found
…file and now tnsping gives me:
C:\Users\MyUser>tnsping MyDATABASE 1
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 14:55:59
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files…
|
| 30 |
Forum: Server Administration «»
Posted on: Mon, 16 November 2015 08:12 «»
By: pkirklewski
Re: TNS-03502: Message 3502 not found
…
C:\Users\MyUser>set ORACLE_HOME=D:\Oracle\product\11.2.0\client_4
C:\Users\MyUser>set PATH=%ORACLE_HOME%\bin;%PATH%
C:\Users\MyUser>where tnsping
D:\Oracle\product\11.2.0\client_4\bin\tnsping.exe
C:\Users\MyUser>tnsping
TNS Ping…
|
| 31 |
Forum: Server Administration «»
Posted on: Mon, 16 November 2015 07:42 «»
By: pkirklewski
Re: TNS-03502: Message 3502 not found
…ow, maybe I've missed smething ?
C:\Users\MyUser>echo %PATH%
C:\Program Files (x86)\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin\;D:\Oracle\product\11.2.0\client_4\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\…
|
| 32 |
Forum: Server Administration «»
Posted on: Mon, 16 November 2015 06:29 «»
By: pkirklewski
TNS-03502: Message 3502 not found
…I run tnsping command, I get :
C:\Users\MyUser>tnsping
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 12:08:08
Copyright (c) 1997, 2010, Oracle. All rights reserved.
TNS-03502: Message 3502 not found; No …
|
| 33 |
Forum: Performance Tuning «»
Posted on: Mon, 09 March 2015 14:30 «»
By: bluetooth420
Re: Same Data, Two machines but different timings. Why?
… of master detail
inv0s
Name Null? Type
MYUSER NOT NULL VARCHAR2(10)
INVNO NOT NULL NUMBER(6)
ADDAID NOT NULL NUMBER(3)
CCODE NOT NULL NUMBER(3)
INVDATE NOT NULL DATE
CORD NOT NULL VARCHAR2(1)
REMARKS VARCHAR2(80)
RETURN2 NOT NULL VARCHAR2(1…
|
| 34 |
Forum: Server Utilities «»
Posted on: Wed, 13 August 2014 06:32 «»
By: superuser
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
…0.2.0.1.0 - 64bit Production
Starting "MYUSER"."SYS_EXPORT_SCHEMA_04": myuser/********@wtwora directory=DMP dumpfile=wtwora.dmp logfile=wtwora.log schemas=WTWORA,SIMONE
Estimate in progress using BLOCKS method...
Processing object…
|
| 35 |
Forum: Server Utilities «»
Posted on: Wed, 13 August 2014 06:02 «»
By: superuser
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
…body SYS.KUPW$WORKER
000000036A7D9CB8 1262 package body SYS.KUPW$WORKER
000000036BC1DEF0 2 anonymous block
Job "MYUSER"."SYS_EXPORT_SCHEMA_04" stopped due to fatal error at 12:22:05
[LF applied [spoiler] tags…
|
| 36 |
Forum: Server Utilities «»
Posted on: Wed, 13 August 2014 05:27 «»
By: superuser
expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
….
I created proper user:
create user myuser identified by somepassword;
grant connect,dba,resource,exp_full_database,imp_full_database to myuser;
create or replace directory DMP as 'F:\DMP\';
grant read, write on directory DMP to myuser;
…
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 29 May 2014 16:04 «»
By: evivekj
Re: how to write an excel in PLSQL
…
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
/
As myuser:
DECLARE
v_fh UTL_FILE.FILE_TYPE;
v_dir VARCHAR2(30) := 'TEST_DIR';
v_file VARCHAR2(30) := 'myfile.xls';
PROCEDURE run_query(p_sql IN VARCHAR2) IS…
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 21 January 2014 00:45 «»
By: Manoj.Gupta.91
Re: Issue in Database Link
…
CREATE DATABASE LINK DBLNK_DB2
CONNECT TO myuser
IDENTIFIED BY myuser
USING 'DB2' ;
When I tried to create db link as below. There was still an issue.
CREATE DATABASE LINK DBLNK_DB2
CONNECT TO myuser
IDENTIFIED BY myuser
USING '10.10…
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 20 January 2014 23:55 «»
By: Manoj.Gupta.91
Issue in Database Link
…
CREATE DATABASE LINK DBLNK_DB2
CONNECT TO myuser
IDENTIFIED BY myuser
USING '10.10.1.250:1521/DB2' ;
SELECT * FROM myuser.mytable@DBLNK_DB2 ;
--above query is giving below error.
ORA-12154: TNS:could not resolve the connect identifier …
|
| 40 |
Forum: Forms «»
Posted on: Thu, 03 October 2013 00:28 «»
By: mahnazzz
file transfer form server directory to client
…
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
/
---------------------------
SQL> select * from all_directories;
OWNER DIRECTORY_NAME
------------------------------ ---------------------
DIRECTORY_PATH…
|
Blog
Search
Help
Members
Register
Login
Home